各位亲如何在一个文件夹下面对所有csv文件里面增加一列,一列为csv文件的名字网上找了段代码改了一下,有报错 哭脸谢谢!
import numpy as np
import openpyxl as op
import pandas as pd
import glob
import os
from pathlib import Path
# coding: utf-8# 给每个excel中的sheet增加一列,值为excel名.xlsxfrom pathlib import Pathimport pandas as pd
path = Path(r'D:\dream\BD2\test_data_X')
#path = r'D:\dream\BD2\test_data_X'
excel_list = [(i.stem, pd.concat(pd.read_excel(i, sheet_name=None))) for i in path.glob("*.csv*")]
data_list = []
for name, data in excel_list:
print(name)
print(data)
data['表名'] = name
data_list.append(data)
result = pd.concat(data_list, ignore_index=True)
result.to_excel(path.joinpath('给每个excel中的sheet增加一列,值为excel名.xlsx'), index=False, encoding='utf-8')
print('添加和合并完成!')
|